package com.neusoft.tijian.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.neusoft.tijian.po.Setmeal;

@Mapper
public interface SetmealMapper {

	//查询体检套餐列表（包含检查项信息）  涉及3表：setmeal(套餐) checkitem(检查项) setmealdetailed(中间表)
	public List<Setmeal> listSetmealByType(Integer type);

	//根据主键查询体检套餐
	@Select("select * from setmeal where smId=#{smId}")
	public Setmeal getSetmealById(Integer smId);
	
}
